home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI592.ASC
< prev
next >
Wrap
Text File
|
1992-11-12
|
2KB
|
67 lines
PRODUCT : Paradox, SQL Link NUMBER : 592
VERSION : 1.0 & up
OS : DOS
DATE : November 12, 1992 PAGE : 1/1
TITLE : Viewing remote tables
Intended Audience:
Persons who have Paradox and SQL Link.
Prerequisites:
Knowledge of how to connect to your SQL server through SQL Link.
Purpose:
This Technical Information sheet discusses a method for viewing
remote tables.
Tables located on the SQL Server (remote tables) can sometimes be
several megabytes in size. Therefore viewing, updating, and
screen refreshing these tables in a client server environment can
cause a great deal of network traffic. By creating a query,
though, you can view a copy of the SQL table and avoid excess
network traffic.
After establishing a connection to your SQL server, create a
replica of the remote table using the SQLSetup script (if you are
using SQL Link 4.0, you can access SQLSetup by selecting
Utilities | SQLSetup from the System Menu). Then select F10 |
Ask and enter the remote table name. Place a CheckPlus ( [Alt]
[F6] ) in every field of the query form, and press [F2] Do-it!.
SQL Link will translate the query and send the SQL code to the
server. The server then optimizes the query, processes it. and
sends the result to a local Answer table. This Answer table can
then be modified, used in a local query, or updated and added
back into the remote SQL table.
Note: When querying a large remote table, make sure that your
private directory has available 2-3 times the diskspace of the
remote table. If it does not, you can view selected records from
the remote table by setting up the query as specified above, and
in addition, specifying select criteria.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.